/****************************************************************************************
This file is part of Proactive Investigator Analytics.

Proactive Investigator Analytics is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

Proactive Investigator Analytics is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with Proactive Investigator Analytics.  If not, see <http://www.gnu.org/licenses/>.

This script creates RiskSecurityDW database.

****************************************************************************************/
USE [master]
GO

/****** Object:  Database [RiskSecurityDW]    Script Date: 05/07/2012 14:31:34 ******/
CREATE DATABASE [RiskSecurityDW] ON  PRIMARY 
( NAME = N'RSDW.mdf', FILENAME = N'C:\san\log-se1\se1r5v1\rsdw.mdf' , SIZE = 1945600KB , MAXSIZE = 2097152KB , FILEGROWTH = 102400KB ), 
 FILEGROUP [RSDW]  DEFAULT 
( NAME = N'RSDW1.ndf', FILENAME = N'C:\SAN\PRI-SE1\se1r1v1\RSDW1.ndf' , SIZE = 1087545600KB , MAXSIZE = 1087582208KB , FILEGROWTH = 6144000KB ), 
( NAME = N'RSDW10.ndf', FILENAME = N'C:\SAN\PRI-SE3\SE3r2v1\RSDW10.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW11.ndf', FILENAME = N'C:\SAN\PRI-SE3\SE3r3v1\RSDW11.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW12.ndf', FILENAME = N'C:\SAN\PRI-SE3\SE3r4v1\RSDW12.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW13.ndf', FILENAME = N'C:\SAN\PRI-SE4\SE4r1v1\RSDW13.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW14.ndf', FILENAME = N'C:\SAN\PRI-SE4\SE4r2v1\RSDW14.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW15.ndf', FILENAME = N'C:\SAN\PRI-SE4\SE4r3v1\RSDW15.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW16.ndf', FILENAME = N'C:\SAN\PRI-SE4\SE4r4v1\RSDW16.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW17.ndf', FILENAME = N'C:\SAN\PRI-SE5\SE5r1v1\RSDW17.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW18.ndf', FILENAME = N'C:\SAN\PRI-SE5\SE5r2v1\RSDW18.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW19.ndf', FILENAME = N'C:\SAN\PRI-SE5\SE5r3v1\RSDW19.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW2.ndf', FILENAME = N'C:\SAN\PRI-SE1\se1r2v1\RSDW2.ndf' , SIZE = 1087343680KB , MAXSIZE = 1087582208KB , FILEGROWTH = 3072000KB ), 
( NAME = N'RSDW20.ndf', FILENAME = N'C:\SAN\PRI-SE5\SE5r4v1\RSDW20.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW21.ndf', FILENAME = N'C:\SAN\PRI-SE6\SE6r1v1\RSDW21.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW22.ndf', FILENAME = N'C:\SAN\PRI-SE6\SE6r2v1\RSDW22.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW23.ndf', FILENAME = N'C:\SAN\PRI-SE6\SE6r3v1\RSDW23.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW24.ndf', FILENAME = N'C:\SAN\PRI-SE6\SE6r4v1\RSDW24.ndf' , SIZE = 1086668800KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW25.ndf', FILENAME = N'C:\san\log-se2\se2r5v1\RSDW25.ndf' , SIZE = 857292800KB , MAXSIZE = 861929472KB , FILEGROWTH = 10240000KB ), 
( NAME = N'RSDW26.ndf', FILENAME = N'C:\SAN\PRI-SE6\SE6R5V1\RSDW26.ndf' , SIZE = 1086910464KB , MAXSIZE = 1087582208KB , FILEGROWTH = 3072000KB ), 
( NAME = N'RSDW3.ndf', FILENAME = N'C:\SAN\PRI-SE1\se1r3v1\RSDW3.ndf' , SIZE = 1087169536KB , MAXSIZE = 1087582208KB , FILEGROWTH = 3072000KB ), 
( NAME = N'RSDW4.ndf', FILENAME = N'C:\SAN\PRI-SE1\se1r4v1\RSDW4.ndf' , SIZE = 1087351808KB , MAXSIZE = 1087582208KB , FILEGROWTH = 4096000KB ), 
( NAME = N'RSDW5.ndf', FILENAME = N'C:\SAN\PRI-SE2\SE2r1v1\RSDW5.ndf' , SIZE = 1086999552KB , MAXSIZE = 1087582208KB , FILEGROWTH = 3072000KB ), 
( NAME = N'RSDW6.ndf', FILENAME = N'C:\SAN\PRI-SE2\SE2r2v1\RSDW6.ndf' , SIZE = 1086842880KB , MAXSIZE = 1087582208KB , FILEGROWTH = 10240000KB ), 
( NAME = N'RSDW7.ndf', FILENAME = N'C:\SAN\PRI-SE2\SE2r3v1\RSDW7.ndf' , SIZE = 1086578688KB , MAXSIZE = 1087582208KB , FILEGROWTH = 2048000KB ), 
( NAME = N'RSDW8.ndf', FILENAME = N'C:\SAN\PRI-SE2\SE2r4v1\RSDW8.ndf' , SIZE = 1087174656KB , MAXSIZE = 1087582208KB , FILEGROWTH = 3072000KB ), 
( NAME = N'RSDW9.ndf', FILENAME = N'C:\SAN\PRI-SE3\SE3r1v1\RSDW9.ndf' , SIZE = 1087331328KB , MAXSIZE = 1087582208KB , FILEGROWTH = 3072000KB )
 LOG ON 
( NAME = N'RSDWLOG1.ldf', FILENAME = N'C:\SAN\LOG-SE3\se3r5v1\RSDWLOG1.ndf' , SIZE = 441600000KB , MAXSIZE = 524288000KB , FILEGROWTH = 51200KB ), 
( NAME = N'RSDWLOG2.ldf', FILENAME = N'C:\SAN\LOG-SE2\se2r5v1\RSDWLOG2.ndf' , SIZE = 313355648KB , MAXSIZE = 524288000KB , FILEGROWTH = 51200KB ), 
( NAME = N'RSDWLOG3.ldf', FILENAME = N'C:\SAN\LOG-SE1\se1r5v1\RSDWLOG3.ndf' , SIZE = 441497600KB , MAXSIZE = 524288000KB , FILEGROWTH = 51200KB )
GO

ALTER DATABASE [RiskSecurityDW] SET COMPATIBILITY_LEVEL = 100
GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [RiskSecurityDW].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

ALTER DATABASE [RiskSecurityDW] SET ANSI_NULL_DEFAULT OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET ANSI_NULLS OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET ANSI_PADDING OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET ANSI_WARNINGS OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET ARITHABORT OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET AUTO_CLOSE OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET AUTO_CREATE_STATISTICS ON 
GO

ALTER DATABASE [RiskSecurityDW] SET AUTO_SHRINK OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET AUTO_UPDATE_STATISTICS ON 
GO

ALTER DATABASE [RiskSecurityDW] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET CURSOR_DEFAULT  GLOBAL 
GO

ALTER DATABASE [RiskSecurityDW] SET CONCAT_NULL_YIELDS_NULL OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET NUMERIC_ROUNDABORT OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET QUOTED_IDENTIFIER OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET RECURSIVE_TRIGGERS OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET  ENABLE_BROKER 
GO

ALTER DATABASE [RiskSecurityDW] SET AUTO_UPDATE_STATISTICS_ASYNC ON 
GO

ALTER DATABASE [RiskSecurityDW] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET TRUSTWORTHY OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET PARAMETERIZATION SIMPLE 
GO

ALTER DATABASE [RiskSecurityDW] SET READ_COMMITTED_SNAPSHOT OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET HONOR_BROKER_PRIORITY OFF 
GO

ALTER DATABASE [RiskSecurityDW] SET  READ_WRITE 
GO

ALTER DATABASE [RiskSecurityDW] SET RECOVERY SIMPLE 
GO

ALTER DATABASE [RiskSecurityDW] SET  MULTI_USER 
GO

ALTER DATABASE [RiskSecurityDW] SET PAGE_VERIFY CHECKSUM  
GO

ALTER DATABASE [RiskSecurityDW] SET DB_CHAINING OFF 
GO

